Overview
Brought to you by YData
Dataset statistics
| Number of variables | 26 |
|---|---|
| Number of observations | 528005 |
| Missing cells | 475317 |
| Missing cells (%) | 3.5% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 99.7 MiB |
| Average record size in memory | 198.0 B |
Variable types
| Numeric | 6 |
|---|---|
| Categorical | 11 |
| Text | 7 |
| DateTime | 2 |
auth is highly overall correlated with length and 1 other fields | High correlation |
browser is highly overall correlated with device and 1 other fields | High correlation |
country is highly overall correlated with region and 1 other fields | High correlation |
device is highly overall correlated with browser and 1 other fields | High correlation |
gender is highly overall correlated with userId | High correlation |
length is highly overall correlated with auth and 3 other fields | High correlation |
level is highly overall correlated with userId | High correlation |
method is highly overall correlated with length and 1 other fields | High correlation |
os is highly overall correlated with region and 1 other fields | High correlation |
page is highly overall correlated with auth and 3 other fields | High correlation |
region is highly overall correlated with country and 2 other fields | High correlation |
sessionId is highly overall correlated with ts and 1 other fields | High correlation |
status is highly overall correlated with length and 1 other fields | High correlation |
ts is highly overall correlated with sessionId | High correlation |
userId is highly overall correlated with browser and 7 other fields | High correlation |
page is highly imbalanced (70.5%) | Imbalance |
auth is highly imbalanced (99.7%) | Imbalance |
method is highly imbalanced (62.1%) | Imbalance |
status is highly imbalanced (73.2%) | Imbalance |
device is highly imbalanced (68.2%) | Imbalance |
country is highly imbalanced (58.9%) | Imbalance |
artist has 95128 (18.0%) missing values | Missing |
song has 95128 (18.0%) missing values | Missing |
length has 95128 (18.0%) missing values | Missing |
browser has 37918 (7.2%) missing values | Missing |
region has 152015 (28.8%) missing values | Missing |
Reproduction
| Analysis started | 2025-10-06 11:01:42.548298 |
|---|---|
| Analysis finished | 2025-10-06 11:02:03.724256 |
| Duration | 21.18 seconds |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
ts
Real number (ℝ)
High correlation
| Distinct | 499351 |
|---|---|
| Distinct (%) | 94.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.5409669 × 1012 |
| Minimum | 1.538352 × 1012 |
|---|---|
| Maximum | 1.5436225 × 1012 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 1.538352 × 1012 |
|---|---|
| 5-th percentile | 1.5386161 × 1012 |
| Q1 | 1.539723 × 1012 |
| median | 1.541007 × 1012 |
| Q3 | 1.5421782 × 1012 |
| 95-th percentile | 1.5433659 × 1012 |
| Maximum | 1.5436225 × 1012 |
| Range | 5.270455 × 109 |
| Interquartile range (IQR) | 2.455156 × 109 |
Descriptive statistics
| Standard deviation | 1.4812331 × 109 |
|---|---|
| Coefficient of variation (CV) | 0.00096123614 |
| Kurtosis | -1.1111058 |
| Mean | 1.5409669 × 1012 |
| Median Absolute Deviation (MAD) | 1.224116 × 109 |
| Skewness | 0.0034125876 |
| Sum | 8.1363824 × 1017 |
| Variance | 2.1940515 × 1018 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 1540991845000 | 4 | < 0.1% |
| 1543497741000 | 4 | < 0.1% |
| 1538527262000 | 4 | < 0.1% |
| 1541548274000 | 4 | < 0.1% |
| 1538744489000 | 4 | < 0.1% |
| 1540833447000 | 4 | < 0.1% |
| 1542299842000 | 4 | < 0.1% |
| 1541007180000 | 4 | < 0.1% |
| 1542052928000 | 4 | < 0.1% |
| 1540578051000 | 4 | < 0.1% |
| Other values (499341) | 527965 |
| Value | Count | Frequency (%) |
| 1538352011000 | 1 | |
| 1538352025000 | 1 | |
| 1538352118000 | 1 | |
| 1538352119000 | 1 | |
| 1538352124000 | 1 | |
| 1538352125000 | 1 | |
| 1538352176000 | 1 | |
| 1538352215000 | 1 | |
| 1538352241000 | 1 | |
| 1538352259000 | 1 |
| Value | Count | Frequency (%) |
| 1543622466000 | 1 | |
| 1543622405000 | 1 | |
| 1543622404000 | 1 | |
| 1543622401000 | 1 | |
| 1543622393000 | 1 | |
| 1543622392000 | 1 | |
| 1543622379000 | 2 | |
| 1543622378000 | 1 | |
| 1543622376000 | 1 | |
| 1543622368000 | 1 |
userId
Real number (ℝ)
High correlation
| Distinct | 448 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 60268.427 |
| Minimum | 2 |
|---|---|
| Maximum | 300051 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 24 |
| Q1 | 96 |
| median | 201 |
| Q3 | 100008 |
| 95-th percentile | 300035 |
| Maximum | 300051 |
| Range | 300049 |
| Interquartile range (IQR) | 99912 |
Descriptive statistics
| Standard deviation | 109898.82 |
|---|---|
| Coefficient of variation (CV) | 1.8234892 |
| Kurtosis | 0.39643461 |
| Mean | 60268.427 |
| Median Absolute Deviation (MAD) | 106 |
| Skewness | 1.4638795 |
| Sum | 3.1822031 × 1010 |
| Variance | 1.2077751 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 92 | 9767 | 1.8% |
| 140 | 7448 | 1.4% |
| 300049 | 7309 | 1.4% |
| 101 | 6842 | 1.3% |
| 300035 | 6810 | 1.3% |
| 195 | 6184 | 1.2% |
| 230 | 6019 | 1.1% |
| 163 | 5965 | 1.1% |
| 250 | 5678 | 1.1% |
| 18 | 5511 | 1.0% |
| Other values (438) | 460472 |
| Value | Count | Frequency (%) |
| 2 | 941 | 0.2% |
| 3 | 25 | < 0.1% |
| 4 | 542 | 0.1% |
| 5 | 278 | 0.1% |
| 6 | 1408 | |
| 7 | 600 | 0.1% |
| 8 | 32 | < 0.1% |
| 9 | 2596 | |
| 10 | 423 | 0.1% |
| 11 | 264 | < 0.1% |
| Value | Count | Frequency (%) |
| 300051 | 1108 | 0.2% |
| 300050 | 79 | < 0.1% |
| 300049 | 7309 | |
| 300048 | 1456 | 0.3% |
| 300047 | 655 | 0.1% |
| 300046 | 790 | 0.1% |
| 300045 | 889 | 0.2% |
| 300044 | 1081 | 0.2% |
| 300043 | 53 | < 0.1% |
| 300042 | 1705 | 0.3% |
sessionId
Real number (ℝ)
High correlation
| Distinct | 4470 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2042.9802 |
| Minimum | 1 |
|---|---|
| Maximum | 4808 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 153 |
| Q1 | 632 |
| median | 1973 |
| Q3 | 3310 |
| 95-th percentile | 4364 |
| Maximum | 4808 |
| Range | 4807 |
| Interquartile range (IQR) | 2678 |
Descriptive statistics
| Standard deviation | 1433.9981 |
|---|---|
| Coefficient of variation (CV) | 0.70191486 |
| Kurtosis | -1.3291119 |
| Mean | 2042.9802 |
| Median Absolute Deviation (MAD) | 1339 |
| Skewness | 0.20244849 |
| Sum | 1.0787038 × 109 |
| Variance | 2056350.7 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1052 | 987 | 0.2% |
| 2860 | 912 | 0.2% |
| 3425 | 884 | 0.2% |
| 4131 | 873 | 0.2% |
| 477 | 817 | 0.2% |
| 2470 | 799 | 0.2% |
| 3513 | 765 | 0.1% |
| 836 | 746 | 0.1% |
| 3821 | 739 | 0.1% |
| 356 | 731 | 0.1% |
| Other values (4460) | 519752 |
| Value | Count | Frequency (%) |
| 1 | 173 | < 0.1% |
| 2 | 54 | < 0.1% |
| 3 | 86 | < 0.1% |
| 4 | 96 | < 0.1% |
| 5 | 119 | < 0.1% |
| 6 | 119 | < 0.1% |
| 7 | 22 | < 0.1% |
| 9 | 627 | |
| 10 | 285 | |
| 11 | 277 |
| Value | Count | Frequency (%) |
| 4808 | 14 | < 0.1% |
| 4801 | 24 | < 0.1% |
| 4799 | 54 | < 0.1% |
| 4791 | 97 | < 0.1% |
| 4790 | 84 | < 0.1% |
| 4779 | 38 | < 0.1% |
| 4777 | 132 | |
| 4774 | 39 | < 0.1% |
| 4771 | 148 | |
| 4767 | 244 |
page
Categorical
High correlation Imbalance
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
| NextSong | |
|---|---|
| Thumbs Up | 23826 |
| Home | 19089 |
| Add to Playlist | 12349 |
| Add Friend | 8087 |
| Other values (14) | 31777 |
Length
| Max length | 25 |
|---|---|
| Median length | 8 |
| Mean length | 8.1342923 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | NextSong |
|---|---|
| 2nd row | NextSong |
| 3rd row | NextSong |
| 4th row | Logout |
| 5th row | NextSong |
Common Values
| Value | Count | Frequency (%) |
| NextSong | 432877 | |
| Thumbs Up | 23826 | 4.5% |
| Home | 19089 | 3.6% |
| Add to Playlist | 12349 | 2.3% |
| Add Friend | 8087 | 1.5% |
| Roll Advert | 7773 | 1.5% |
| Logout | 5990 | 1.1% |
| Thumbs Down | 4911 | 0.9% |
| Downgrade | 3811 | 0.7% |
| Settings | 2964 | 0.6% |
| Other values (9) | 6328 | 1.2% |
Length
| Value | Count | Frequency (%) |
| nextsong | 432877 | |
| thumbs | 28737 | 4.8% |
| up | 23826 | 4.0% |
| add | 20436 | 3.4% |
| home | 19089 | 3.2% |
| to | 12349 | 2.1% |
| playlist | 12349 | 2.1% |
| friend | 8087 | 1.4% |
| roll | 7773 | 1.3% |
| advert | 7773 | 1.3% |
| Other values (13) | 25092 | 4.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 494733 | |
| t | 480064 | |
| e | 479985 | |
| n | 453847 | |
| g | 447599 | |
| S | 437415 | |
| N | 432877 | |
| x | 432877 | |
| 70383 | 1.6% | |
| d | 61915 | 1.4% |
| Other values (26) | 503252 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4294947 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 494733 | |
| t | 480064 | |
| e | 479985 | |
| n | 453847 | |
| g | 447599 | |
| S | 437415 | |
| N | 432877 | |
| x | 432877 | |
| 70383 | 1.6% | |
| d | 61915 | 1.4% |
| Other values (26) | 503252 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4294947 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 494733 | |
| t | 480064 | |
| e | 479985 | |
| n | 453847 | |
| g | 447599 | |
| S | 437415 | |
| N | 432877 | |
| x | 432877 | |
| 70383 | 1.6% | |
| d | 61915 | 1.4% |
| Other values (26) | 503252 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4294947 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 494733 | |
| t | 480064 | |
| e | 479985 | |
| n | 453847 | |
| g | 447599 | |
| S | 437415 | |
| N | 432877 | |
| x | 432877 | |
| 70383 | 1.6% | |
| d | 61915 | 1.4% |
| Other values (26) | 503252 |
auth
Categorical
High correlation Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
| Logged In | |
|---|---|
| Cancelled | 99 |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Logged In |
|---|---|
| 2nd row | Logged In |
| 3rd row | Logged In |
| 4th row | Logged In |
| 5th row | Logged In |
Common Values
| Value | Count | Frequency (%) |
| Logged In | 527906 | |
| Cancelled | 99 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| logged | 527906 | |
| in | 527906 | |
| cancelled | 99 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| g | 1055812 | |
| e | 528104 | |
| d | 528005 | |
| n | 528005 | |
| L | 527906 | |
| o | 527906 | |
| 527906 | ||
| I | 527906 | |
| l | 198 | < 0.1% |
| C | 99 | < 0.1% |
| Other values (2) | 198 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4752045 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| g | 1055812 | |
| e | 528104 | |
| d | 528005 | |
| n | 528005 | |
| L | 527906 | |
| o | 527906 | |
| 527906 | ||
| I | 527906 | |
| l | 198 | < 0.1% |
| C | 99 | < 0.1% |
| Other values (2) | 198 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4752045 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| g | 1055812 | |
| e | 528104 | |
| d | 528005 | |
| n | 528005 | |
| L | 527906 | |
| o | 527906 | |
| 527906 | ||
| I | 527906 | |
| l | 198 | < 0.1% |
| C | 99 | < 0.1% |
| Other values (2) | 198 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4752045 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| g | 1055812 | |
| e | 528104 | |
| d | 528005 | |
| n | 528005 | |
| L | 527906 | |
| o | 527906 | |
| 527906 | ||
| I | 527906 | |
| l | 198 | < 0.1% |
| C | 99 | < 0.1% |
| Other values (2) | 198 | < 0.1% |
method
Categorical
High correlation Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
| PUT | |
|---|---|
| GET | 38877 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PUT |
|---|---|
| 2nd row | PUT |
| 3rd row | PUT |
| 4th row | PUT |
| 5th row | PUT |
Common Values
| Value | Count | Frequency (%) |
| PUT | 489128 | |
| GET | 38877 | 7.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| put | 489128 | |
| get | 38877 | 7.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 528005 | |
| P | 489128 | |
| U | 489128 | |
| G | 38877 | 2.5% |
| E | 38877 | 2.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1584015 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| T | 528005 | |
| P | 489128 | |
| U | 489128 | |
| G | 38877 | 2.5% |
| E | 38877 | 2.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1584015 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| T | 528005 | |
| P | 489128 | |
| U | 489128 | |
| G | 38877 | 2.5% |
| E | 38877 | 2.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1584015 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| T | 528005 | |
| P | 489128 | |
| U | 489128 | |
| G | 38877 | 2.5% |
| E | 38877 | 2.5% |
status
Categorical
High correlation Imbalance
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
| 200 | |
|---|---|
| 307 | 43902 |
| 404 | 503 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 200 |
|---|---|
| 2nd row | 200 |
| 3rd row | 200 |
| 4th row | 307 |
| 5th row | 200 |
Common Values
| Value | Count | Frequency (%) |
| 200 | 483600 | |
| 307 | 43902 | 8.3% |
| 404 | 503 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 200 | 483600 | |
| 307 | 43902 | 8.3% |
| 404 | 503 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1011605 | |
| 2 | 483600 | |
| 3 | 43902 | 2.8% |
| 7 | 43902 | 2.8% |
| 4 | 1006 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1584015 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1011605 | |
| 2 | 483600 | |
| 3 | 43902 | 2.8% |
| 7 | 43902 | 2.8% |
| 4 | 1006 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1584015 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1011605 | |
| 2 | 483600 | |
| 3 | 43902 | 2.8% |
| 7 | 43902 | 2.8% |
| 4 | 1006 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1584015 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1011605 | |
| 2 | 483600 | |
| 3 | 43902 | 2.8% |
| 7 | 43902 | 2.8% |
| 4 | 1006 | 0.1% |
level
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 515.9 KiB |
| paid | |
|---|---|
| free |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | free |
|---|---|
| 2nd row | free |
| 3rd row | paid |
| 4th row | paid |
| 5th row | paid |
Common Values
| Value | Count | Frequency (%) |
| paid | 418044 | |
| free | 109961 | 20.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| paid | 418044 | |
| free | 109961 | 20.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| p | 418044 | |
| a | 418044 | |
| i | 418044 | |
| d | 418044 | |
| e | 219922 | |
| f | 109961 | 5.2% |
| r | 109961 | 5.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2112020 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| p | 418044 | |
| a | 418044 | |
| i | 418044 | |
| d | 418044 | |
| e | 219922 | |
| f | 109961 | 5.2% |
| r | 109961 | 5.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2112020 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| p | 418044 | |
| a | 418044 | |
| i | 418044 | |
| d | 418044 | |
| e | 219922 | |
| f | 109961 | 5.2% |
| r | 109961 | 5.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2112020 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| p | 418044 | |
| a | 418044 | |
| i | 418044 | |
| d | 418044 | |
| e | 219922 | |
| f | 109961 | 5.2% |
| r | 109961 | 5.2% |
itemInSession
Real number (ℝ)
| Distinct | 1006 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 107.77899 |
| Minimum | 0 |
|---|---|
| Maximum | 1005 |
| Zeros | 5147 |
| Zeros (%) | 1.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 27 |
| median | 68 |
| Q3 | 148 |
| 95-th percentile | 349 |
| Maximum | 1005 |
| Range | 1005 |
| Interquartile range (IQR) | 121 |
Descriptive statistics
| Standard deviation | 116.86479 |
|---|---|
| Coefficient of variation (CV) | 1.0843002 |
| Kurtosis | 5.6652906 |
| Mean | 107.77899 |
| Median Absolute Deviation (MAD) | 50 |
| Skewness | 2.0657049 |
| Sum | 56907848 |
| Variance | 13657.378 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 5691 | 1.1% |
| 3 | 5646 | 1.1% |
| 4 | 5586 | 1.1% |
| 5 | 5522 | 1.0% |
| 6 | 5431 | 1.0% |
| 1 | 5401 | 1.0% |
| 7 | 5330 | 1.0% |
| 8 | 5258 | 1.0% |
| 0 | 5147 | 1.0% |
| 9 | 5146 | 1.0% |
| Other values (996) | 473847 |
| Value | Count | Frequency (%) |
| 0 | 5147 | |
| 1 | 5401 | |
| 2 | 5691 | |
| 3 | 5646 | |
| 4 | 5586 | |
| 5 | 5522 | |
| 6 | 5431 | |
| 7 | 5330 | |
| 8 | 5258 | |
| 9 | 5146 |
| Value | Count | Frequency (%) |
| 1005 | 1 | |
| 1004 | 1 | |
| 1003 | 1 | |
| 1002 | 1 | |
| 1001 | 1 | |
| 1000 | 1 | |
| 999 | 1 | |
| 998 | 1 | |
| 997 | 1 | |
| 996 | 1 |
location
Text
| Distinct | 192 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 39 |
| Mean length | 25.48594 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Corpus Christi, TX |
|---|---|
| 2nd row | Houston-The Woodlands-Sugar Land, TX |
| 3rd row | Orlando-Kissimmee-Sanford, FL |
| 4th row | Orlando-Kissimmee-Sanford, FL |
| 5th row | Mobile, AL |
| Value | Count | Frequency (%) |
| ca | 78171 | 5.5% |
| city | 51680 | 3.6% |
| new | 45353 | 3.2% |
| tx | 42442 | 3.0% |
| ny-nj-pa | 40156 | 2.8% |
| york-newark-jersey | 40156 | 2.8% |
| los | 34278 | 2.4% |
| angeles-long | 34278 | 2.4% |
| beach-anaheim | 34278 | 2.4% |
| fl | 32129 | 2.3% |
| Other values (301) | 985094 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 969488 | 7.2% |
| 890010 | 6.6% | |
| a | 877940 | 6.5% |
| - | 866585 | 6.4% |
| o | 742296 | 5.5% |
| n | 722917 | 5.4% |
| r | 620281 | 4.6% |
| i | 553202 | 4.1% |
| l | 546456 | 4.1% |
| , | 528005 | 3.9% |
| Other values (47) | 6139524 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 13456704 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 969488 | 7.2% |
| 890010 | 6.6% | |
| a | 877940 | 6.5% |
| - | 866585 | 6.4% |
| o | 742296 | 5.5% |
| n | 722917 | 5.4% |
| r | 620281 | 4.6% |
| i | 553202 | 4.1% |
| l | 546456 | 4.1% |
| , | 528005 | 3.9% |
| Other values (47) | 6139524 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 13456704 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 969488 | 7.2% |
| 890010 | 6.6% | |
| a | 877940 | 6.5% |
| - | 866585 | 6.4% |
| o | 742296 | 5.5% |
| n | 722917 | 5.4% |
| r | 620281 | 4.6% |
| i | 553202 | 4.1% |
| l | 546456 | 4.1% |
| , | 528005 | 3.9% |
| Other values (47) | 6139524 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 13456704 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 969488 | 7.2% |
| 890010 | 6.6% | |
| a | 877940 | 6.5% |
| - | 866585 | 6.4% |
| o | 742296 | 5.5% |
| n | 722917 | 5.4% |
| r | 620281 | 4.6% |
| i | 553202 | 4.1% |
| l | 546456 | 4.1% |
| , | 528005 | 3.9% |
| Other values (47) | 6139524 |
userAgent
Text
| Distinct | 71 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
Length
| Max length | 139 |
|---|---|
| Median length | 130 |
| Mean length | 104.43651 |
| Min length | 63 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.125 Safari/537.36" |
|---|---|
| 2nd row | "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.143 Safari/537.36" |
| 3rd row | "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.143 Safari/537.36" |
| 4th row | "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.143 Safari/537.36" |
| 5th row | Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Firefox/31.0 |
| Value | Count | Frequency (%) |
| mozilla/5.0 | 528005 | 8.9% |
| like | 423151 | 7.1% |
| gecko | 392666 | 6.6% |
| khtml | 376525 | 6.3% |
| applewebkit/537.36 | 275306 | 4.6% |
| safari/537.36 | 275306 | 4.6% |
| windows | 270433 | 4.6% |
| nt | 270433 | 4.6% |
| os | 263029 | 4.4% |
| wow64 | 244545 | 4.1% |
| Other values (87) | 2611635 |
Most occurring characters
| Value | Count | Frequency (%) |
| 5403029 | 9.8% | |
| . | 3054166 | 5.5% |
| i | 2558574 | 4.6% |
| e | 2493717 | 4.5% |
| l | 2110007 | 3.8% |
| o | 2083060 | 3.8% |
| 0 | 2000294 | 3.6% |
| 3 | 1996021 | 3.6% |
| / | 1958131 | 3.6% |
| 5 | 1776953 | 3.2% |
| Other values (52) | 29709045 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 55142997 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 5403029 | 9.8% | |
| . | 3054166 | 5.5% |
| i | 2558574 | 4.6% |
| e | 2493717 | 4.5% |
| l | 2110007 | 3.8% |
| o | 2083060 | 3.8% |
| 0 | 2000294 | 3.6% |
| 3 | 1996021 | 3.6% |
| / | 1958131 | 3.6% |
| 5 | 1776953 | 3.2% |
| Other values (52) | 29709045 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 55142997 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 5403029 | 9.8% | |
| . | 3054166 | 5.5% |
| i | 2558574 | 4.6% |
| e | 2493717 | 4.5% |
| l | 2110007 | 3.8% |
| o | 2083060 | 3.8% |
| 0 | 2000294 | 3.6% |
| 3 | 1996021 | 3.6% |
| / | 1958131 | 3.6% |
| 5 | 1776953 | 3.2% |
| Other values (52) | 29709045 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 55142997 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 5403029 | 9.8% | |
| . | 3054166 | 5.5% |
| i | 2558574 | 4.6% |
| e | 2493717 | 4.5% |
| l | 2110007 | 3.8% |
| o | 2083060 | 3.8% |
| 0 | 2000294 | 3.6% |
| 3 | 1996021 | 3.6% |
| / | 1958131 | 3.6% |
| 5 | 1776953 | 3.2% |
| Other values (52) | 29709045 |
lastName
Text
| Distinct | 275 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 8 |
| Mean length | 6.1544569 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Morales |
|---|---|
| 2nd row | Larson |
| 3rd row | Santiago |
| 4th row | Santiago |
| 5th row | Campos |
| Value | Count | Frequency (%) |
| reed | 12767 | 2.4% |
| taylor | 12666 | 2.4% |
| stewart | 11720 | 2.2% |
| robinson | 11291 | 2.1% |
| johnson | 11170 | 2.1% |
| williams | 10291 | 1.9% |
| jones | 10075 | 1.9% |
| white | 9287 | 1.8% |
| cook | 8665 | 1.6% |
| larson | 7205 | 1.4% |
| Other values (265) | 422868 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 323463 | 10.0% |
| o | 308681 | 9.5% |
| n | 303111 | 9.3% |
| a | 269898 | 8.3% |
| r | 267747 | 8.2% |
| s | 196827 | 6.1% |
| l | 192133 | 5.9% |
| i | 158369 | 4.9% |
| t | 109353 | 3.4% |
| h | 93232 | 2.9% |
| Other values (36) | 1026770 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3249584 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 323463 | 10.0% |
| o | 308681 | 9.5% |
| n | 303111 | 9.3% |
| a | 269898 | 8.3% |
| r | 267747 | 8.2% |
| s | 196827 | 6.1% |
| l | 192133 | 5.9% |
| i | 158369 | 4.9% |
| t | 109353 | 3.4% |
| h | 93232 | 2.9% |
| Other values (36) | 1026770 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3249584 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 323463 | 10.0% |
| o | 308681 | 9.5% |
| n | 303111 | 9.3% |
| a | 269898 | 8.3% |
| r | 267747 | 8.2% |
| s | 196827 | 6.1% |
| l | 192133 | 5.9% |
| i | 158369 | 4.9% |
| t | 109353 | 3.4% |
| h | 93232 | 2.9% |
| Other values (36) | 1026770 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3249584 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 323463 | 10.0% |
| o | 308681 | 9.5% |
| n | 303111 | 9.3% |
| a | 269898 | 8.3% |
| r | 267747 | 8.2% |
| s | 196827 | 6.1% |
| l | 192133 | 5.9% |
| i | 158369 | 4.9% |
| t | 109353 | 3.4% |
| h | 93232 | 2.9% |
| Other values (36) | 1026770 |
firstName
Text
| Distinct | 345 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 5.9241522 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Joseph |
|---|---|
| 2nd row | Sawyer |
| 3rd row | Maverick |
| 4th row | Maverick |
| 5th row | Gianna |
| Value | Count | Frequency (%) |
| joseph | 13108 | 2.5% |
| riley | 10426 | 2.0% |
| sophia | 9245 | 1.8% |
| colin | 8736 | 1.7% |
| daniel | 7476 | 1.4% |
| lucero | 7448 | 1.4% |
| alex | 7400 | 1.4% |
| janiyah | 6810 | 1.3% |
| sofia | 6629 | 1.3% |
| everett | 6523 | 1.2% |
| Other values (335) | 444204 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 398961 | |
| e | 305198 | 9.8% |
| n | 283718 | 9.1% |
| i | 252052 | 8.1% |
| l | 229182 | 7.3% |
| o | 162158 | 5.2% |
| r | 150706 | 4.8% |
| y | 143410 | 4.6% |
| s | 142229 | 4.5% |
| h | 93949 | 3.0% |
| Other values (40) | 966419 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3127982 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 398961 | |
| e | 305198 | 9.8% |
| n | 283718 | 9.1% |
| i | 252052 | 8.1% |
| l | 229182 | 7.3% |
| o | 162158 | 5.2% |
| r | 150706 | 4.8% |
| y | 143410 | 4.6% |
| s | 142229 | 4.5% |
| h | 93949 | 3.0% |
| Other values (40) | 966419 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3127982 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 398961 | |
| e | 305198 | 9.8% |
| n | 283718 | 9.1% |
| i | 252052 | 8.1% |
| l | 229182 | 7.3% |
| o | 162158 | 5.2% |
| r | 150706 | 4.8% |
| y | 143410 | 4.6% |
| s | 142229 | 4.5% |
| h | 93949 | 3.0% |
| Other values (40) | 966419 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3127982 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 398961 | |
| e | 305198 | 9.8% |
| n | 283718 | 9.1% |
| i | 252052 | 8.1% |
| l | 229182 | 7.3% |
| o | 162158 | 5.2% |
| r | 150706 | 4.8% |
| y | 143410 | 4.6% |
| s | 142229 | 4.5% |
| h | 93949 | 3.0% |
| Other values (40) | 966419 |
registration
Real number (ℝ)
| Distinct | 448 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.5355234 × 1012 |
| Minimum | 1.5098542 × 1012 |
|---|---|
| Maximum | 1.5430739 × 1012 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 1.5098542 × 1012 |
|---|---|
| 5-th percentile | 1.5290262 × 1012 |
| Q1 | 1.5343678 × 1012 |
| median | 1.5365559 × 1012 |
| Q3 | 1.5376119 × 1012 |
| 95-th percentile | 1.5382898 × 1012 |
| Maximum | 1.5430739 × 1012 |
| Range | 3.3219681 × 1010 |
| Interquartile range (IQR) | 3.244138 × 109 |
Descriptive statistics
| Standard deviation | 3.0787255 × 109 |
|---|---|
| Coefficient of variation (CV) | 0.0020050007 |
| Kurtosis | 8.0389685 |
| Mean | 1.5355234 × 1012 |
| Median Absolute Deviation (MAD) | 1.341543 × 109 |
| Skewness | -2.2673353 |
| Sum | 8.1076404 × 1017 |
| Variance | 9.4785507 × 1018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1536403972000 | 9767 | 1.8% |
| 1536642109000 | 7448 | 1.4% |
| 1537523064000 | 7309 | 1.4% |
| 1535066380000 | 6842 | 1.3% |
| 1538178448000 | 6810 | 1.3% |
| 1536082261000 | 6184 | 1.2% |
| 1527341164000 | 6019 | 1.1% |
| 1533175710000 | 5965 | 1.1% |
| 1536859413000 | 5678 | 1.1% |
| 1535623466000 | 5511 | 1.0% |
| Other values (438) | 460472 |
| Value | Count | Frequency (%) |
| 1509854193000 | 418 | 0.1% |
| 1519397713000 | 1123 | |
| 1521380675000 | 1408 | |
| 1522076012000 | 523 | 0.1% |
| 1522793334000 | 1616 | |
| 1523464964000 | 620 | 0.1% |
| 1523721066000 | 797 | |
| 1523777521000 | 1447 | |
| 1526739206000 | 1982 | |
| 1526838391000 | 366 | 0.1% |
| Value | Count | Frequency (%) |
| 1543073874000 | 128 | < 0.1% |
| 1542205030000 | 100 | < 0.1% |
| 1541041865000 | 1108 | 0.2% |
| 1539437340000 | 228 | < 0.1% |
| 1538347306000 | 1974 | |
| 1538336771000 | 4816 | |
| 1538334792000 | 1389 | 0.3% |
| 1538333829000 | 2072 | |
| 1538333222000 | 1772 | 0.3% |
| 1538332310000 | 53 | < 0.1% |
gender
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 515.9 KiB |
| M | |
|---|---|
| F |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | M |
|---|---|
| 2nd row | M |
| 3rd row | M |
| 4th row | M |
| 5th row | F |
Common Values
| Value | Count | Frequency (%) |
| M | 302612 | |
| F | 225393 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| m | 302612 | |
| f | 225393 |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 302612 | |
| F | 225393 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 528005 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| M | 302612 | |
| F | 225393 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 528005 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| M | 302612 | |
| F | 225393 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 528005 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| M | 302612 | |
| F | 225393 |
artist
Text
Missing
| Distinct | 21247 |
|---|---|
| Distinct (%) | 4.9% |
| Missing | 95128 |
| Missing (%) | 18.0% |
| Memory size | 4.0 MiB |
Length
| Max length | 318 |
|---|---|
| Median length | 156 |
| Mean length | 13.210217 |
| Min length | 1 |
Unique
| Unique | 5729 ? |
|---|---|
| Unique (%) | 1.3% |
Sample
| 1st row | Martin Orford |
|---|---|
| 2nd row | John Brown's Body |
| 3rd row | Afroman |
| 4th row | Lily Allen |
| 5th row | Carter USM |
| Value | Count | Frequency (%) |
| the | 50522 | 5.3% |
| 28592 | 3.0% | |
| of | 11040 | 1.2% |
| and | 6533 | 0.7% |
| featuring | 5193 | 0.5% |
| black | 4569 | 0.5% |
| kings | 4031 | 0.4% |
| leon | 3551 | 0.4% |
| coldplay | 3445 | 0.4% |
| john | 3407 | 0.4% |
| Other values (20001) | 837917 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 536697 | 9.4% |
| 526051 | 9.2% | |
| a | 424852 | 7.4% |
| i | 341369 | 6.0% |
| n | 330068 | 5.8% |
| o | 304441 | 5.3% |
| r | 302742 | 5.3% |
| l | 245870 | 4.3% |
| s | 236683 | 4.1% |
| t | 218714 | 3.8% |
| Other values (122) | 2250912 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5718399 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 536697 | 9.4% |
| 526051 | 9.2% | |
| a | 424852 | 7.4% |
| i | 341369 | 6.0% |
| n | 330068 | 5.8% |
| o | 304441 | 5.3% |
| r | 302742 | 5.3% |
| l | 245870 | 4.3% |
| s | 236683 | 4.1% |
| t | 218714 | 3.8% |
| Other values (122) | 2250912 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5718399 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 536697 | 9.4% |
| 526051 | 9.2% | |
| a | 424852 | 7.4% |
| i | 341369 | 6.0% |
| n | 330068 | 5.8% |
| o | 304441 | 5.3% |
| r | 302742 | 5.3% |
| l | 245870 | 4.3% |
| s | 236683 | 4.1% |
| t | 218714 | 3.8% |
| Other values (122) | 2250912 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5718399 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 536697 | 9.4% |
| 526051 | 9.2% | |
| a | 424852 | 7.4% |
| i | 341369 | 6.0% |
| n | 330068 | 5.8% |
| o | 304441 | 5.3% |
| r | 302742 | 5.3% |
| l | 245870 | 4.3% |
| s | 236683 | 4.1% |
| t | 218714 | 3.8% |
| Other values (122) | 2250912 |
song
Text
Missing
| Distinct | 80279 |
|---|---|
| Distinct (%) | 18.5% |
| Missing | 95128 |
| Missing (%) | 18.0% |
| Memory size | 4.0 MiB |
Length
| Max length | 214 |
|---|---|
| Median length | 140 |
| Mean length | 17.901175 |
| Min length | 1 |
Unique
| Unique | 37236 ? |
|---|---|
| Unique (%) | 8.6% |
Sample
| 1st row | Grand Designs |
|---|---|
| 2nd row | Bulls |
| 3rd row | Because I Got High |
| 4th row | Smile (Radio Edit) |
| 5th row | Airplane Food |
| Value | Count | Frequency (%) |
| the | 54800 | 3.9% |
| version | 43554 | 3.1% |
| album | 33820 | 2.4% |
| you | 24547 | 1.8% |
| a | 18325 | 1.3% |
| of | 17999 | 1.3% |
| me | 17359 | 1.2% |
| i | 17101 | 1.2% |
| in | 15648 | 1.1% |
| to | 14754 | 1.1% |
| Other values (38097) | 1144011 |
Most occurring characters
| Value | Count | Frequency (%) |
| 971832 | 12.5% | |
| e | 717767 | 9.3% |
| o | 469008 | 6.1% |
| n | 402660 | 5.2% |
| i | 402593 | 5.2% |
| a | 400952 | 5.2% |
| r | 361702 | 4.7% |
| t | 313249 | 4.0% |
| s | 274727 | 3.5% |
| l | 273662 | 3.5% |
| Other values (147) | 3160855 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7749007 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 971832 | 12.5% | |
| e | 717767 | 9.3% |
| o | 469008 | 6.1% |
| n | 402660 | 5.2% |
| i | 402593 | 5.2% |
| a | 400952 | 5.2% |
| r | 361702 | 4.7% |
| t | 313249 | 4.0% |
| s | 274727 | 3.5% |
| l | 273662 | 3.5% |
| Other values (147) | 3160855 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7749007 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 971832 | 12.5% | |
| e | 717767 | 9.3% |
| o | 469008 | 6.1% |
| n | 402660 | 5.2% |
| i | 402593 | 5.2% |
| a | 400952 | 5.2% |
| r | 361702 | 4.7% |
| t | 313249 | 4.0% |
| s | 274727 | 3.5% |
| l | 273662 | 3.5% |
| Other values (147) | 3160855 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7749007 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 971832 | 12.5% | |
| e | 717767 | 9.3% |
| o | 469008 | 6.1% |
| n | 402660 | 5.2% |
| i | 402593 | 5.2% |
| a | 400952 | 5.2% |
| r | 361702 | 4.7% |
| t | 313249 | 4.0% |
| s | 274727 | 3.5% |
| l | 273662 | 3.5% |
| Other values (147) | 3160855 |
length
Real number (ℝ)
High correlation Missing
| Distinct | 16679 |
|---|---|
| Distinct (%) | 3.9% |
| Missing | 95128 |
| Missing (%) | 18.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 248.66459 |
| Minimum | 0.78322 |
|---|---|
| Maximum | 3024.6657 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 MiB |
Quantile statistics
| Minimum | 0.78322 |
|---|---|
| 5-th percentile | 138.16118 |
| Q1 | 199.3922 |
| median | 234.00444 |
| Q3 | 276.79302 |
| 95-th percentile | 402.76591 |
| Maximum | 3024.6657 |
| Range | 3023.8825 |
| Interquartile range (IQR) | 77.40082 |
Descriptive statistics
| Standard deviation | 98.41267 |
|---|---|
| Coefficient of variation (CV) | 0.39576471 |
| Kurtosis | 76.191342 |
| Mean | 248.66459 |
| Median Absolute Deviation (MAD) | 38.03429 |
| Skewness | 5.0288732 |
| Sum | 1.0764118 × 108 |
| Variance | 9685.0535 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 239.3073 | 2320 | 0.4% |
| 348.57751 | 1962 | 0.4% |
| 201.79546 | 1735 | 0.3% |
| 655.77751 | 1343 | 0.3% |
| 277.15873 | 1239 | 0.2% |
| 219.66322 | 1069 | 0.2% |
| 224.67873 | 1049 | 0.2% |
| 220.89098 | 1023 | 0.2% |
| 252.21179 | 896 | 0.2% |
| 236.09424 | 870 | 0.2% |
| Other values (16669) | 419371 | |
| (Missing) | 95128 | 18.0% |
| Value | Count | Frequency (%) |
| 0.78322 | 1 | < 0.1% |
| 1.12281 | 3 | |
| 2.16771 | 1 | < 0.1% |
| 3.94404 | 1 | < 0.1% |
| 4.04853 | 5 | |
| 4.17914 | 1 | < 0.1% |
| 4.8322 | 2 | < 0.1% |
| 5.53751 | 1 | < 0.1% |
| 6.3473 | 2 | < 0.1% |
| 6.66077 | 3 |
| Value | Count | Frequency (%) |
| 3024.66567 | 10 | |
| 2960.5873 | 1 | < 0.1% |
| 2743.09179 | 1 | < 0.1% |
| 2732.2771 | 1 | < 0.1% |
| 2709.2371 | 1 | < 0.1% |
| 2626.45506 | 1 | < 0.1% |
| 2594.87302 | 14 | |
| 2520.99873 | 21 | |
| 2441.19465 | 1 | < 0.1% |
| 2390.20363 | 1 | < 0.1% |
ts_dt
Date
| Distinct | 499351 |
|---|---|
| Distinct (%) | 94.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
| Minimum | 2018-10-01 00:00:11+00:00 |
|---|---|
| Maximum | 2018-12-01 00:01:06+00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
registration_dt
Date
| Distinct | 448 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
| Minimum | 2017-11-05 03:56:33+00:00 |
|---|---|
| Maximum | 2018-11-24 15:37:54+00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
os
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
| Windows | |
|---|---|
| macOS | |
| Linux | 25028 |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 6.0243577 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | macOS |
|---|---|
| 2nd row | macOS |
| 3rd row | macOS |
| 4th row | macOS |
| 5th row | Windows |
Common Values
| Value | Count | Frequency (%) |
| Windows | 270433 | |
| macOS | 232544 | |
| Linux | 25028 | 4.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| windows | 270433 | |
| macos | 232544 | |
| linux | 25028 | 4.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 295461 | |
| n | 295461 | |
| W | 270433 | |
| d | 270433 | |
| o | 270433 | |
| w | 270433 | |
| s | 270433 | |
| m | 232544 | |
| a | 232544 | |
| c | 232544 | |
| Other values (5) | 540172 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3180891 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 295461 | |
| n | 295461 | |
| W | 270433 | |
| d | 270433 | |
| o | 270433 | |
| w | 270433 | |
| s | 270433 | |
| m | 232544 | |
| a | 232544 | |
| c | 232544 | |
| Other values (5) | 540172 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3180891 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 295461 | |
| n | 295461 | |
| W | 270433 | |
| d | 270433 | |
| o | 270433 | |
| w | 270433 | |
| s | 270433 | |
| m | 232544 | |
| a | 232544 | |
| c | 232544 | |
| Other values (5) | 540172 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3180891 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 295461 | |
| n | 295461 | |
| W | 270433 | |
| d | 270433 | |
| o | 270433 | |
| w | 270433 | |
| s | 270433 | |
| m | 232544 | |
| a | 232544 | |
| c | 232544 | |
| Other values (5) | 540172 |
browser
Categorical
High correlation Missing
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 37918 |
| Missing (%) | 7.2% |
| Memory size | 4.0 MiB |
| Chrome | |
|---|---|
| Firefox | |
| Safari |
Length
| Max length | 7 |
|---|---|
| Median length | 6 |
| Mean length | 6.231718 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Chrome |
|---|---|
| 2nd row | Chrome |
| 3rd row | Chrome |
| 4th row | Chrome |
| 5th row | Firefox |
Common Values
| Value | Count | Frequency (%) |
| Chrome | 275306 | |
| Firefox | 113562 | |
| Safari | 101219 | 19.2% |
| (Missing) | 37918 | 7.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| chrome | 275306 | |
| firefox | 113562 | |
| safari | 101219 | 20.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 490087 | |
| o | 388868 | |
| e | 388868 | |
| C | 275306 | |
| h | 275306 | |
| m | 275306 | |
| i | 214781 | |
| f | 214781 | |
| a | 202438 | |
| F | 113562 | 3.7% |
| Other values (2) | 214781 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3054084 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 490087 | |
| o | 388868 | |
| e | 388868 | |
| C | 275306 | |
| h | 275306 | |
| m | 275306 | |
| i | 214781 | |
| f | 214781 | |
| a | 202438 | |
| F | 113562 | 3.7% |
| Other values (2) | 214781 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3054084 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 490087 | |
| o | 388868 | |
| e | 388868 | |
| C | 275306 | |
| h | 275306 | |
| m | 275306 | |
| i | 214781 | |
| f | 214781 | |
| a | 202438 | |
| F | 113562 | 3.7% |
| Other values (2) | 214781 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3054084 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 490087 | |
| o | 388868 | |
| e | 388868 | |
| C | 275306 | |
| h | 275306 | |
| m | 275306 | |
| i | 214781 | |
| f | 214781 | |
| a | 202438 | |
| F | 113562 | 3.7% |
| Other values (2) | 214781 |
device
Categorical
High correlation Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
| Desktop | |
|---|---|
| Mobile | 30485 |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 6.9422638 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Desktop |
|---|---|
| 2nd row | Desktop |
| 3rd row | Desktop |
| 4th row | Desktop |
| 5th row | Desktop |
Common Values
| Value | Count | Frequency (%) |
| Desktop | 497520 | |
| Mobile | 30485 | 5.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| desktop | 497520 | |
| mobile | 30485 | 5.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 528005 | |
| o | 528005 | |
| D | 497520 | |
| s | 497520 | |
| k | 497520 | |
| t | 497520 | |
| p | 497520 | |
| M | 30485 | 0.8% |
| b | 30485 | 0.8% |
| i | 30485 | 0.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3665550 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 528005 | |
| o | 528005 | |
| D | 497520 | |
| s | 497520 | |
| k | 497520 | |
| t | 497520 | |
| p | 497520 | |
| M | 30485 | 0.8% |
| b | 30485 | 0.8% |
| i | 30485 | 0.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3665550 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 528005 | |
| o | 528005 | |
| D | 497520 | |
| s | 497520 | |
| k | 497520 | |
| t | 497520 | |
| p | 497520 | |
| M | 30485 | 0.8% |
| b | 30485 | 0.8% |
| i | 30485 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3665550 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 528005 | |
| o | 528005 | |
| D | 497520 | |
| s | 497520 | |
| k | 497520 | |
| t | 497520 | |
| p | 497520 | |
| M | 30485 | 0.8% |
| b | 30485 | 0.8% |
| i | 30485 | 0.8% |
city
Text
| Distinct | 187 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
Length
| Max length | 42 |
|---|---|
| Median length | 32 |
| Mean length | 20.136891 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Corpus Christi |
|---|---|
| 2nd row | Houston-The Woodlands-Sugar Land |
| 3rd row | Orlando-Kissimmee-Sanford |
| 4th row | Orlando-Kissimmee-Sanford |
| 5th row | Mobile |
| Value | Count | Frequency (%) |
| city | 51680 | 5.8% |
| new | 45353 | 5.1% |
| york-newark-jersey | 40156 | 4.5% |
| los | 34278 | 3.9% |
| angeles-long | 34278 | 3.9% |
| beach-anaheim | 34278 | 3.9% |
| san | 18557 | 2.1% |
| boston-cambridge-newton | 17574 | 2.0% |
| chicago-naperville-elgin | 15194 | 1.7% |
| francisco-oakland-hayward | 11428 | 1.3% |
| Other values (231) | 587234 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 969488 | 9.1% |
| a | 877940 | 8.3% |
| o | 742296 | 7.0% |
| n | 722917 | 6.8% |
| - | 629150 | 5.9% |
| r | 620281 | 5.8% |
| i | 553202 | 5.2% |
| l | 546456 | 5.1% |
| s | 490164 | 4.6% |
| t | 464881 | 4.4% |
| Other values (44) | 4015604 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 10632379 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 969488 | 9.1% |
| a | 877940 | 8.3% |
| o | 742296 | 7.0% |
| n | 722917 | 6.8% |
| - | 629150 | 5.9% |
| r | 620281 | 5.8% |
| i | 553202 | 5.2% |
| l | 546456 | 5.1% |
| s | 490164 | 4.6% |
| t | 464881 | 4.4% |
| Other values (44) | 4015604 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 10632379 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 969488 | 9.1% |
| a | 877940 | 8.3% |
| o | 742296 | 7.0% |
| n | 722917 | 6.8% |
| - | 629150 | 5.9% |
| r | 620281 | 5.8% |
| i | 553202 | 5.2% |
| l | 546456 | 5.1% |
| s | 490164 | 4.6% |
| t | 464881 | 4.4% |
| Other values (44) | 4015604 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 10632379 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 969488 | 9.1% |
| a | 877940 | 8.3% |
| o | 742296 | 7.0% |
| n | 722917 | 6.8% |
| - | 629150 | 5.9% |
| r | 620281 | 5.8% |
| i | 553202 | 5.2% |
| l | 546456 | 5.1% |
| s | 490164 | 4.6% |
| t | 464881 | 4.4% |
| Other values (44) | 4015604 |
region
Categorical
High correlation Missing
| Distinct | 43 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 152015 |
| Missing (%) | 28.8% |
| Memory size | 4.0 MiB |
| CA | |
|---|---|
| TX | |
| FL | |
| NC | 18024 |
| GA | 16041 |
| Other values (38) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | TX |
|---|---|
| 2nd row | TX |
| 3rd row | FL |
| 4th row | FL |
| 5th row | AL |
Common Values
| Value | Count | Frequency (%) |
| CA | 78171 | |
| TX | 42442 | 8.0% |
| FL | 32129 | 6.1% |
| NC | 18024 | 3.4% |
| GA | 16041 | 3.0% |
| AZ | 13997 | 2.7% |
| MI | 13724 | 2.6% |
| CO | 12485 | 2.4% |
| WI | 12273 | 2.3% |
| TN | 11090 | 2.1% |
| Other values (33) | 125614 | |
| (Missing) | 152015 |
Length
| Value | Count | Frequency (%) |
| ca | 78171 | |
| tx | 42442 | 11.3% |
| fl | 32129 | 8.5% |
| nc | 18024 | 4.8% |
| ga | 16041 | 4.3% |
| az | 13997 | 3.7% |
| mi | 13724 | 3.7% |
| co | 12485 | 3.3% |
| wi | 12273 | 3.3% |
| tn | 11090 | 2.9% |
| Other values (33) | 125614 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 151684 | |
| C | 116170 | |
| T | 66259 | |
| N | 63275 | |
| L | 52796 | 7.0% |
| I | 43554 | 5.8% |
| X | 42442 | 5.6% |
| M | 34763 | 4.6% |
| F | 32129 | 4.3% |
| W | 22603 | 3.0% |
| Other values (14) | 126305 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 751980 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 151684 | |
| C | 116170 | |
| T | 66259 | |
| N | 63275 | |
| L | 52796 | 7.0% |
| I | 43554 | 5.8% |
| X | 42442 | 5.6% |
| M | 34763 | 4.6% |
| F | 32129 | 4.3% |
| W | 22603 | 3.0% |
| Other values (14) | 126305 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 751980 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 151684 | |
| C | 116170 | |
| T | 66259 | |
| N | 63275 | |
| L | 52796 | 7.0% |
| I | 43554 | 5.8% |
| X | 42442 | 5.6% |
| M | 34763 | 4.6% |
| F | 32129 | 4.3% |
| W | 22603 | 3.0% |
| Other values (14) | 126305 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 751980 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 151684 | |
| C | 116170 | |
| T | 66259 | |
| N | 63275 | |
| L | 52796 | 7.0% |
| I | 43554 | 5.8% |
| X | 42442 | 5.6% |
| M | 34763 | 4.6% |
| F | 32129 | 4.3% |
| W | 22603 | 3.0% |
| Other values (14) | 126305 |
country
Categorical
High correlation Imbalance
| Distinct | 28 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
| USA | |
|---|---|
| NY-NJ-PA | |
| MA-NH | 17574 |
| IL-IN-WI | 15194 |
| MN-WI | 7479 |
| Other values (23) |
Length
| Max length | 11 |
|---|---|
| Median length | 3 |
| Mean length | 4.0611453 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | USA |
|---|---|
| 2nd row | USA |
| 3rd row | USA |
| 4th row | USA |
| 5th row | USA |
Common Values
| Value | Count | Frequency (%) |
| USA | 375990 | |
| NY-NJ-PA | 40156 | 7.6% |
| MA-NH | 17574 | 3.3% |
| IL-IN-WI | 15194 | 2.9% |
| MN-WI | 7479 | 1.4% |
| KY-IN | 7457 | 1.4% |
| PA-NJ-DE-MD | 6962 | 1.3% |
| MO-KS | 6956 | 1.3% |
| VA-NC | 6624 | 1.3% |
| DC-VA-MD-WV | 6181 | 1.2% |
| Other values (18) | 37432 | 7.1% |
Length
| Value | Count | Frequency (%) |
| usa | 375990 | |
| ny-nj-pa | 40156 | 7.6% |
| ma-nh | 17574 | 3.3% |
| il-in-wi | 15194 | 2.9% |
| mn-wi | 7479 | 1.4% |
| ky-in | 7457 | 1.4% |
| pa-nj-de-md | 6962 | 1.3% |
| mo-ks | 6956 | 1.3% |
| va-nc | 6624 | 1.3% |
| dc-va-md-wv | 6181 | 1.2% |
| Other values (18) | 37432 | 7.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 474753 | |
| S | 390022 | |
| U | 376184 | |
| - | 237435 | |
| N | 158604 | 7.4% |
| I | 77055 | 3.6% |
| M | 64932 | 3.0% |
| J | 49735 | 2.3% |
| P | 49735 | 2.3% |
| Y | 48927 | 2.3% |
| Other values (12) | 216923 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2144305 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 474753 | |
| S | 390022 | |
| U | 376184 | |
| - | 237435 | |
| N | 158604 | 7.4% |
| I | 77055 | 3.6% |
| M | 64932 | 3.0% |
| J | 49735 | 2.3% |
| P | 49735 | 2.3% |
| Y | 48927 | 2.3% |
| Other values (12) | 216923 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2144305 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 474753 | |
| S | 390022 | |
| U | 376184 | |
| - | 237435 | |
| N | 158604 | 7.4% |
| I | 77055 | 3.6% |
| M | 64932 | 3.0% |
| J | 49735 | 2.3% |
| P | 49735 | 2.3% |
| Y | 48927 | 2.3% |
| Other values (12) | 216923 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2144305 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 474753 | |
| S | 390022 | |
| U | 376184 | |
| - | 237435 | |
| N | 158604 | 7.4% |
| I | 77055 | 3.6% |
| M | 64932 | 3.0% |
| J | 49735 | 2.3% |
| P | 49735 | 2.3% |
| Y | 48927 | 2.3% |
| Other values (12) | 216923 |
Interactions
Correlations
| auth | browser | country | device | gender | itemInSession | length | level | method | os | page | region | registration | sessionId | status | ts | userId | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| auth | 1.000 | 0.001 | 0.004 | 0.002 | 0.000 | 0.001 | 1.000 | 0.003 | 0.048 | 0.000 | 1.000 | 0.011 | 0.003 | 0.008 | 0.004 | 0.001 | 0.058 |
| browser | 0.001 | 1.000 | 0.334 | 0.505 | 0.005 | 0.051 | 0.000 | 0.019 | 0.000 | 0.400 | 0.006 | 0.441 | 0.135 | 0.065 | 0.001 | 0.048 | 1.000 |
| country | 0.004 | 0.334 | 1.000 | 0.444 | 0.305 | 0.054 | 0.000 | 0.171 | 0.024 | 0.330 | 0.010 | 1.000 | 0.266 | 0.124 | 0.004 | 0.092 | 1.000 |
| device | 0.002 | 0.505 | 0.444 | 1.000 | 0.025 | 0.021 | 0.000 | 0.016 | 0.001 | 0.279 | 0.007 | 0.192 | 0.212 | 0.036 | 0.003 | 0.053 | 1.000 |
| gender | 0.000 | 0.005 | 0.305 | 0.025 | 1.000 | 0.032 | 0.000 | 0.002 | 0.000 | 0.105 | 0.003 | 0.432 | 0.126 | 0.080 | 0.000 | 0.037 | 1.000 |
| itemInSession | 0.001 | 0.051 | 0.054 | 0.021 | 0.032 | 1.000 | 0.001 | 0.281 | 0.044 | 0.038 | 0.024 | 0.079 | -0.005 | 0.142 | 0.004 | 0.076 | -0.089 |
| length | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.001 | 1.000 | 0.002 | 1.000 | 0.000 | 1.000 | 0.001 | -0.000 | -0.003 | 1.000 | -0.003 | 0.000 |
| level | 0.003 | 0.019 | 0.171 | 0.016 | 0.002 | 0.281 | 0.002 | 1.000 | 0.124 | 0.001 | 0.250 | 0.211 | 0.080 | 0.252 | 0.005 | 0.265 | 0.688 |
| method | 0.048 | 0.000 | 0.024 | 0.001 | 0.000 | 0.044 | 1.000 | 0.124 | 1.000 | 0.000 | 1.000 | 0.031 | 0.012 | 0.037 | 0.138 | 0.032 | 0.094 |
| os | 0.000 | 0.400 | 0.330 | 0.279 | 0.105 | 0.038 | 0.000 | 0.001 | 0.000 | 1.000 | 0.001 | 0.558 | 0.176 | 0.064 | 0.000 | 0.055 | 1.000 |
| page | 1.000 | 0.006 | 0.010 | 0.007 | 0.003 | 0.024 | 1.000 | 0.250 | 1.000 | 0.001 | 1.000 | 0.015 | 0.008 | 0.027 | 1.000 | 0.022 | 0.051 |
| region | 0.011 | 0.441 | 1.000 | 0.192 | 0.432 | 0.079 | 0.001 | 0.211 | 0.031 | 0.558 | 0.015 | 1.000 | 0.461 | 0.192 | 0.013 | 0.147 | 1.000 |
| registration | 0.003 | 0.135 | 0.266 | 0.212 | 0.126 | -0.005 | -0.000 | 0.080 | 0.012 | 0.176 | 0.008 | 0.461 | 1.000 | -0.054 | 0.004 | 0.019 | 0.028 |
| sessionId | 0.008 | 0.065 | 0.124 | 0.036 | 0.080 | 0.142 | -0.003 | 0.252 | 0.037 | 0.064 | 0.027 | 0.192 | -0.054 | 1.000 | 0.019 | 0.693 | -0.545 |
| status | 0.004 | 0.001 | 0.004 | 0.003 | 0.000 | 0.004 | 1.000 | 0.005 | 0.138 | 0.000 | 1.000 | 0.013 | 0.004 | 0.019 | 1.000 | 0.002 | 0.028 |
| ts | 0.001 | 0.048 | 0.092 | 0.053 | 0.037 | 0.076 | -0.003 | 0.265 | 0.032 | 0.055 | 0.022 | 0.147 | 0.019 | 0.693 | 0.002 | 1.000 | -0.063 |
| userId | 0.058 | 1.000 | 1.000 | 1.000 | 1.000 | -0.089 | 0.000 | 0.688 | 0.094 | 1.000 | 0.051 | 1.000 | 0.028 | -0.545 | 0.028 | -0.063 | 1.000 |
Missing values
Sample
| ts | userId | sessionId | page | auth | method | status | level | itemInSession | location | userAgent | lastName | firstName | registration | gender | artist | song | length | ts_dt | registration_dt | os | browser | device | city | region | country | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1538352011000 | 293 | 292 | NextSong | Logged In | PUT | 200 | free | 20 | Corpus Christi, TX | "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.125 Safari/537.36" | Morales | Joseph | 1532063507000 | M | Martin Orford | Grand Designs | 597.55057 | 2018-10-01 00:00:11+00:00 | 2018-07-20 05:11:47+00:00 | macOS | Chrome | Desktop | Corpus Christi | TX | USA |
| 1 | 1538352025000 | 98 | 97 | NextSong | Logged In | PUT | 200 | free | 74 | Houston-The Woodlands-Sugar Land, TX | "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.143 Safari/537.36" | Larson | Sawyer | 1538069638000 | M | John Brown's Body | Bulls | 380.21179 | 2018-10-01 00:00:25+00:00 | 2018-09-27 17:33:58+00:00 | macOS | Chrome | Desktop | Houston-The Woodlands-Sugar Land | TX | USA |
| 2 | 1538352118000 | 179 | 178 | NextSong | Logged In | PUT | 200 | paid | 184 | Orlando-Kissimmee-Sanford, FL | "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.143 Safari/537.36" | Santiago | Maverick | 1535953455000 | M | Afroman | Because I Got High | 202.37016 | 2018-10-01 00:01:58+00:00 | 2018-09-03 05:44:15+00:00 | macOS | Chrome | Desktop | Orlando-Kissimmee-Sanford | FL | USA |
| 3 | 1538352119000 | 179 | 178 | Logout | Logged In | PUT | 307 | paid | 185 | Orlando-Kissimmee-Sanford, FL | "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.143 Safari/537.36" | Santiago | Maverick | 1535953455000 | M | <NA> | <NA> | NaN | 2018-10-01 00:01:59+00:00 | 2018-09-03 05:44:15+00:00 | macOS | Chrome | Desktop | Orlando-Kissimmee-Sanford | FL | USA |
| 4 | 1538352124000 | 246 | 245 | NextSong | Logged In | PUT | 200 | paid | 22 | Mobile, AL | Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Firefox/31.0 | Campos | Gianna | 1535931018000 | F | Lily Allen | Smile (Radio Edit) | 194.53342 | 2018-10-01 00:02:04+00:00 | 2018-09-02 23:30:18+00:00 | Windows | Firefox | Desktop | Mobile | AL | USA |
| 5 | 1538352125000 | 163 | 162 | NextSong | Logged In | PUT | 200 | paid | 266 | Rochester, MN | "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.94 Safari/537.36" | Gordon | Sofia | 1533175710000 | F | Carter USM | Airplane Food | 138.29179 | 2018-10-01 00:02:05+00:00 | 2018-08-02 02:08:30+00:00 | macOS | Chrome | Desktop | Rochester | MN | USA |
| 6 | 1538352176000 | 179 | 178 | Home | Logged In | GET | 200 | paid | 190 | Orlando-Kissimmee-Sanford, FL | "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.143 Safari/537.36" | Santiago | Maverick | 1535953455000 | M | <NA> | <NA> | NaN | 2018-10-01 00:02:56+00:00 | 2018-09-03 05:44:15+00:00 | macOS | Chrome | Desktop | Orlando-Kissimmee-Sanford | FL | USA |
| 7 | 1538352215000 | 175 | 442 | NextSong | Logged In | PUT | 200 | free | 107 | El Campo, TX | "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.94 Safari/537.36" | Castaneda | Lacey | 1537536032000 | F | Aerosmith | Walk This Way | 220.39465 | 2018-10-01 00:03:35+00:00 | 2018-09-21 13:20:32+00:00 | macOS | Chrome | Desktop | El Campo | TX | USA |
| 8 | 1538352241000 | 100 | 497 | Home | Logged In | GET | 200 | free | 0 | Dallas-Fort Worth-Arlington, TX | Mozilla/5.0 (Windows NT 6.1; WOW64; rv:30.0) Gecko/20100101 Firefox/30.0 | Larson | Colin | 1537982255000 | M | <NA> | <NA> | NaN | 2018-10-01 00:04:01+00:00 | 2018-09-26 17:17:35+00:00 | Windows | Firefox | Desktop | Dallas-Fort Worth-Arlington | TX | USA |
| 9 | 1538352259000 | 100 | 497 | NextSong | Logged In | PUT | 200 | free | 1 | Dallas-Fort Worth-Arlington, TX | Mozilla/5.0 (Windows NT 6.1; WOW64; rv:30.0) Gecko/20100101 Firefox/30.0 | Larson | Colin | 1537982255000 | M | Amy Winehouse | Teach Me Tonight | 201.50812 | 2018-10-01 00:04:19+00:00 | 2018-09-26 17:17:35+00:00 | Windows | Firefox | Desktop | Dallas-Fort Worth-Arlington | TX | USA |
| ts | userId | sessionId | page | auth | method | status | level | itemInSession | location | userAgent | lastName | firstName | registration | gender | artist | song | length | ts_dt | registration_dt | os | browser | device | city | region | country | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 527995 | 1543622376000 | 27 | 4518 | NextSong | Logged In | PUT | 200 | paid | 177 | Hartford-West Hartford-East Hartford, CT | "Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.143 Safari/537.36" | Raymond | Ethan | 1534245996000 | M | Marilyn Manson | The Beautiful People | 218.82730 | 2018-11-30 23:59:36+00:00 | 2018-08-14 11:26:36+00:00 | Windows | Chrome | Desktop | Hartford-West Hartford-East Hartford | CT | USA |
| 527996 | 1543622378000 | 86 | 4704 | NextSong | Logged In | PUT | 200 | paid | 226 | Jacksonville, FL | Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Firefox/31.0 | Reilly | Jaxon | 1531760527000 | M | The Derek Trucks Band | I'd Rather Be Blind_ Crippled And Crazy | 276.53179 | 2018-11-30 23:59:38+00:00 | 2018-07-16 17:02:07+00:00 | Windows | Firefox | Desktop | Jacksonville | FL | USA |
| 527997 | 1543622379000 | 153 | 4683 | NextSong | Logged In | PUT | 200 | paid | 197 | Greensboro-High Point, NC | "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.125 Safari/537.36" | Poole | Andrew | 1537085185000 | M | Benny Neyman | Waarom Fluister Ik Je Naam Nog | 224.75710 | 2018-11-30 23:59:39+00:00 | 2018-09-16 08:06:25+00:00 | Windows | Chrome | Desktop | Greensboro-High Point | NC | USA |
| 527998 | 1543622379000 | 46 | 4429 | NextSong | Logged In | PUT | 200 | free | 20 | Los Angeles-Long Beach-Anaheim, CA | "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.143 Safari/537.36" | Rodriguez | Adelaida | 1537767796000 | F | Dwight Yoakam | You're The One | 239.30730 | 2018-11-30 23:59:39+00:00 | 2018-09-24 05:43:16+00:00 | macOS | Chrome | Desktop | Los Angeles-Long Beach-Anaheim | CA | USA |
| 527999 | 1543622392000 | 300038 | 966 | NextSong | Logged In | PUT | 200 | paid | 36 | Lakeland-Winter Haven, FL | "Mozilla/5.0 (iPhone; CPU iPhone OS 7_1_2 like Mac OS X) AppleWebKit/537.51.2 (KHTML, like Gecko) Version/7.0 Mobile/11D257 Safari/9537.53" | Reed | Aiden | 1535616235000 | M | Hinder | Lips Of An Angel | 262.05995 | 2018-11-30 23:59:52+00:00 | 2018-08-30 08:03:55+00:00 | macOS | Safari | Mobile | Lakeland-Winter Haven | FL | USA |
| 528000 | 1543622393000 | 163 | 4669 | Home | Logged In | GET | 200 | paid | 21 | Rochester, MN | "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.94 Safari/537.36" | Gordon | Sofia | 1533175710000 | F | <NA> | <NA> | NaN | 2018-11-30 23:59:53+00:00 | 2018-08-02 02:08:30+00:00 | macOS | Chrome | Desktop | Rochester | MN | USA |
| 528001 | 1543622401000 | 300015 | 981 | NextSong | Logged In | PUT | 200 | paid | 109 | San Antonio-New Braunfels, TX | "Mozilla/5.0 (iPhone; CPU iPhone OS 7_1_2 like Mac OS X) AppleWebKit/537.51.2 (KHTML, like Gecko) Version/7.0 Mobile/11D257 Safari/9537.53" | White | Joshua | 1528780738000 | M | Jack Johnson | Do You Remember | 144.06485 | 2018-12-01 00:00:01+00:00 | 2018-06-12 05:18:58+00:00 | macOS | Safari | Mobile | San Antonio-New Braunfels | TX | USA |
| 528002 | 1543622404000 | 163 | 4669 | NextSong | Logged In | PUT | 200 | paid | 22 | Rochester, MN | "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.94 Safari/537.36" | Gordon | Sofia | 1533175710000 | F | Deep Blue Something | Breakfast At Tiffany's | 257.22730 | 2018-12-01 00:00:04+00:00 | 2018-08-02 02:08:30+00:00 | macOS | Chrome | Desktop | Rochester | MN | USA |
| 528003 | 1543622405000 | 100008 | 405 | NextSong | Logged In | PUT | 200 | paid | 78 | Los Angeles-Long Beach-Anaheim, CA | Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:31.0) Gecko/20100101 Firefox/31.0 | Stone | Bryanna | 1537440271000 | F | Creedence Clearwater Revival | Long As I Can See The Light | 213.10649 | 2018-12-01 00:00:05+00:00 | 2018-09-20 10:44:31+00:00 | macOS | Firefox | Desktop | Los Angeles-Long Beach-Anaheim | CA | USA |
| 528004 | 1543622466000 | 200030 | 666 | NextSong | Logged In | PUT | 200 | paid | 95 | Chicago-Naperville-Elgin, IL-IN-WI | "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_4) AppleWebKit/537.78.2 (KHTML, like Gecko) Version/7.0.6 Safari/537.78.2" | Sandoval | Aven | 1538334792000 | M | Limp Bizkit | The Truth | 325.51138 | 2018-12-01 00:01:06+00:00 | 2018-09-30 19:13:12+00:00 | macOS | Safari | Desktop | Chicago-Naperville-Elgin | None | IL-IN-WI |